﻿CREATE TABLE [dbo].[TabAccountIndex] (
    [UserID]   numeric(18,0) NOT NULL identity(1, 1),
    [UserName] nvarchar(20)  COLLATE Chinese_PRC_CI_AS NOT NULL,
    [Password] nvarchar(20)  COLLATE Chinese_PRC_CI_AS NOT NULL,

    CONSTRAINT [PK_TabUser] PRIMARY KEY CLUSTERED ([UserID] asc),
    CONSTRAINT [IX_TabUser] UNIQUE NONCLUSTERED ([UserName] asc)
);
GO
